﻿CREATE TABLE [dbo].[AW_Setting] (
    [SettingId]             UNIQUEIDENTIFIER NOT NULL,
    [CompanyName]           NVARCHAR (250)   NULL,
    [CompanyDesc]           NVARCHAR (MAX)   NULL,
    [CompanyLogo]           NVARCHAR (50)    NULL,
    [RelistBoolean]         TINYINT          NULL,
    [CloseFormat]           NVARCHAR (250)   NULL,
    [Old]                   INT              NULL,
    [New]                   INT              NULL,
    [OldColor]              NVARCHAR (7)     NULL,
    [NewColor]              NVARCHAR (7)     NULL,
    [UpdateColor]           NVARCHAR (7)     NULL,
    [StampDuty]             DECIMAL (18, 2)  NULL,
    [ListingPercent]        DECIMAL (18, 2)  NULL,
    [OpenFormat]            NVARCHAR (250)   NULL,
    [InvoiceFormat]         NVARCHAR (250)   NULL,
    [CompanyInitial]        NVARCHAR (5)     NULL,
    [TabBoolean]            TINYINT          NULL,
    [CloseUseOpen]          TINYINT          NULL,
    [InvoiceUseClose]       TINYINT          NULL,
    [InvoiceUseOpen]        TINYINT          NULL,
    [ReminderDeleteDays]    TINYINT          NULL,
    [IntActiveAnnouncement] INT              NULL,
    [IntActiveReminder]     INT              NULL,
    [IntReminderRenew]      INT              NULL,
    [StampDutyFrom]         DECIMAL (18, 2)  NULL,
    [StampDutyTo]           DECIMAL (18, 2)  NULL,
    [FeedbackColor0]        NVARCHAR (7)     DEFAULT (N'#FF66CC') NULL,
    [FeedbackColor1]        NVARCHAR (7)     DEFAULT (N'#FF66CC') NULL,
    [FeedbackColor2]        NVARCHAR (7)     DEFAULT (N'#FF66CC') NULL,
    [FeedbackColor3]        NVARCHAR (7)     DEFAULT (N'#FF66CC') NULL,
    [FeedbackColor4]        NVARCHAR (7)     DEFAULT (N'#FF66CC') NULL,
    [FeedbackColor5]        NVARCHAR (7)     DEFAULT (N'#FF66CC') NULL,
    [FeedbackColor6]        NVARCHAR (7)     DEFAULT (N'#FF66CC') NULL,
    [FeedbackColor7]        NVARCHAR (7)     DEFAULT (N'#FF66CC') NULL,
    [FeedbackColor8]        NCHAR (7)        DEFAULT (N'#FF66CC') NULL,
    CONSTRAINT [PK_AW_Setting] PRIMARY KEY CLUSTERED ([SettingId] ASC)
);




GO



GO



GO



GO



GO


